Release 10.1A: OpenEdge Reporting:
Deploying Crystal Reports

Adding a new data source

Once you have created your sample database and determined the proper isolation level, you can proceed to configure the ODBC Client.

To configure the ODBC client:

From the Windows Start menu, choose Settings Control Panel Administrative Tools. The Administrative Tools dialog box appears:



Double-click Data Sources (ODBC) in the Control Panel dialog box:



The ODBC Administrator displays the ODBC Data Source Administrator dialog box:



Click Add to display a list of installed drivers. The Create New Data Source dialog box appears:



Highlight the DataDirect 4.20 32-BIT Progress SQL v10.0BIP driver, then click Finish to display the ODBC Progress SQL-92 Driver Setup dialog box:



Specify values for the following:
Data Source Name — Identifies data source configuration name. For example, Accounting.
Description — An optional long description of the data source name. For example, My Accounting Database.
Host Name — The name of the system where the database or database broker is located.
Port Number — The system port number setup for the database listener process.
Database Name — The name of the database to which you want to connect by default.
User ID — The user name used to connect to your OpenEdge database. Your ODBC application can override this value, or you can override it in the Logon dialog box or connection string.
Click the Advanced tab and specify values for the following:
Default isolation level — use READ UNCOMMITTED.
Fetch array size — The number of rows the driver retrieves when fetching from the server. This is not the number of rows given to the user. The default is 50. Enter 500.
Click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box. the Driver Setup dialog box will display a logon dialog box:



Enter your user identification and password and Click OK.The OpenEdge SQL driver displays a message box that states the ODBC driver has successfully connected to the database:

Now that you have created a sample database, configured your ODBC driver and established a connection to it, you can use Crystal Reports to create a report using the sample database.